Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1119
Missing cells	4600
Missing cells (%)	27.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	131.3 KiB
Average record size in memory	120.1 B

Variable types

Categorical	4
Numeric	10
Unsupported	1

Alerts

`_id` has a high cardinality: 1119 distinct values	High cardinality
`userId` has a high cardinality: 258 distinct values	High cardinality
`bonusPointsEarned` is highly overall correlated with `bonusPointsEarnedReason`	High correlation
`createDate` is highly overall correlated with `dateScanned` and 4 other fields	High correlation
`dateScanned` is highly overall correlated with `createDate` and 4 other fields	High correlation
`finishedDate` is highly overall correlated with `createDate` and 5 other fields	High correlation
`modifyDate` is highly overall correlated with `createDate` and 4 other fields	High correlation
`pointsAwardedDate` is highly overall correlated with `createDate` and 5 other fields	High correlation
`pointsEarned` is highly overall correlated with `bonusPointsEarnedReason` and 1 other fields	High correlation
`purchaseDate` is highly overall correlated with `createDate` and 5 other fields	High correlation
`purchasedItemCount` is highly overall correlated with `totalSpent`	High correlation
`totalSpent` is highly overall correlated with `purchasedItemCount` and 1 other fields	High correlation
`bonusPointsEarnedReason` is highly overall correlated with `bonusPointsEarned` and 2 other fields	High correlation
`rewardsReceiptStatus` is highly overall correlated with `finishedDate` and 3 other fields	High correlation
`bonusPointsEarned` has 575 (51.4%) missing values	Missing
`bonusPointsEarnedReason` has 575 (51.4%) missing values	Missing
`finishedDate` has 551 (49.2%) missing values	Missing
`pointsAwardedDate` has 582 (52.0%) missing values	Missing
`pointsEarned` has 510 (45.6%) missing values	Missing
`purchaseDate` has 448 (40.0%) missing values	Missing
`purchasedItemCount` has 484 (43.3%) missing values	Missing
`rewardsReceiptItemList` has 440 (39.3%) missing values	Missing
`totalSpent` has 435 (38.9%) missing values	Missing
`_id` is uniformly distributed	Uniform
`_id` has unique values	Unique
`rewardsReceiptItemList` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`purchasedItemCount` has 15 (1.3%) zeros	Zeros
`totalSpent` has 15 (1.3%) zeros	Zeros

Reproduction

Analysis started	2023-07-19 20:07:42.611522
Analysis finished	2023-07-19 20:08:12.922463
Duration	30.31 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

_id
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	1119
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

5ff1e1eb0a720f0523000575	1
601b48df0a720f05f4000238	1
601c11410a720f05f400028e	1
601c2d630a7214ad280002a7	1
601be7120a720f05f400027a	1
Other values (1114)	1114

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	26856
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1119 ?
Unique (%)	100.0%

Sample

1st row	5ff1e1eb0a720f0523000575
2nd row	5ff1e1bb0a720f052300056b
3rd row	5ff1e1f10a720f052300057a
4th row	5ff1e1ee0a7214ada100056f
5th row	5ff1e1d20a7214ada1000561

Common Values

Value	Count	Frequency (%)
5ff1e1eb0a720f0523000575	1	0.1%
601b48df0a720f05f4000238	1	0.1%
601c11410a720f05f400028e	1	0.1%
601c2d630a7214ad280002a7	1	0.1%
601be7120a720f05f400027a	1	0.1%
601b5cc90a7214ad2800023a	1	0.1%
601bc2bd0a7214ad28000262	1	0.1%
601c2c3a0a720f05f40002a2	1	0.1%
601b730f0a7214ad28000243	1	0.1%
601bd57e0a7214ad2800026d	1	0.1%
Other values (1109)	1109	99.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
5ff1e1eb0a720f0523000575	1	0.1%
5ff36d860a720f05230005a7	1	0.1%
5ff1e1f10a720f052300057a	1	0.1%
5ff1e1ee0a7214ada100056f	1	0.1%
5ff1e1d20a7214ada1000561	1	0.1%
5ff1e1e40a7214ada1000566	1	0.1%
5ff1e1cd0a720f052300056f	1	0.1%
5ff1e1a40a720f0523000569	1	0.1%
5ff1e1ed0a7214ada100056e	1	0.1%
5ff473a90a7214ada10005c2	1	0.1%
Other values (1109)	1109	99.1%

Most occurring characters

Value	Count	Frequency (%)
0	7683	28.6%
a	2271	8.5%
2	2212	8.2%
f	1789	6.7%
7	1774	6.6%
1	1759	6.5%
5	1614	6.0%
6	1373	5.1%
4	1177	4.4%
d	1030	3.8%
Other values (6)	4174	15.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19948	74.3%
Lowercase Letter	6908	25.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7683	38.5%
2	2212	11.1%
7	1774	8.9%
1	1759	8.8%
5	1614	8.1%
6	1373	6.9%
4	1177	5.9%
8	898	4.5%
3	885	4.4%
9	573	2.9%

Lowercase Letter

Value	Count	Frequency (%)
a	2271	32.9%
f	1789	25.9%
d	1030	14.9%
c	731	10.6%
e	610	8.8%
b	477	6.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	19948	74.3%
Latin	6908	25.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	7683	38.5%
2	2212	11.1%
7	1774	8.9%
1	1759	8.8%
5	1614	8.1%
6	1373	6.9%
4	1177	5.9%
8	898	4.5%
3	885	4.4%
9	573	2.9%

Latin

Value	Count	Frequency (%)
a	2271	32.9%
f	1789	25.9%
d	1030	14.9%
c	731	10.6%
e	610	8.8%
b	477	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	7683	28.6%
a	2271	8.5%
2	2212	8.2%
f	1789	6.7%
7	1774	6.6%
1	1759	6.5%
5	1614	6.0%
6	1373	5.1%
4	1177	4.4%
d	1030	3.8%
Other values (6)	4174	15.5%

bonusPointsEarned
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	12
Distinct (%)	2.2%
Missing	575
Missing (%)	51.4%
Infinite	0
Infinite (%)	0.0%
Mean	238.89338

Minimum	5
Maximum	750
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	5
5-th percentile	5
Q1	5
median	45
Q3	500
95-th percentile	750
Maximum	750
Range	745
Interquartile range (IQR)	495

Descriptive statistics

Standard deviation	299.09173
Coefficient of variation (CV)	1.2519883
Kurtosis	-0.91662581
Mean	238.89338
Median Absolute Deviation (MAD)	40
Skewness	0.89974537
Sum	129958
Variance	89455.863
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
5	183	16.4%
750	119	10.6%
25	71	6.3%
250	31	2.8%
45	31	2.8%
500	30	2.7%
150	27	2.4%
300	26	2.3%
100	18	1.6%
27	6	0.5%
Other values (2)	2	0.2%
(Missing)	575	51.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	183	16.4%
21	1	0.1%
25	71	6.3%
27	6	0.5%
40	1	0.1%
45	31	2.8%
100	18	1.6%
150	27	2.4%
250	31	2.8%
300	26	2.3%

Value	Count	Frequency (%)
750	119	10.6%
500	30	2.7%
300	26	2.3%
250	31	2.8%
150	27	2.4%
100	18	1.6%
45	31	2.8%
40	1	0.1%
27	6	0.5%
25	71	6.3%

bonusPointsEarnedReason
Categorical

HIGH CORRELATION MISSING

Distinct	9
Distinct (%)	1.7%
Missing	575
Missing (%)	51.4%
Memory size	8.9 KiB

All-receipts receipt bonus	183
Receipt number 1 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	119
COMPLETE_NONPARTNER_RECEIPT	71
COMPLETE_PARTNER_RECEIPT	39
Receipt number 3 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	31
Other values (4)	101

Length

Max length	83
Median length	27
Mean length	52.286765
Min length	24

Characters and Unicode

Total characters	28444
Distinct characters	46
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)
2nd row	Receipt number 5 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)
3rd row	All-receipts receipt bonus
4th row	All-receipts receipt bonus
5th row	All-receipts receipt bonus

Common Values

Value	Count	Frequency (%)
All-receipts receipt bonus	183	16.4%
Receipt number 1 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	119	10.6%
COMPLETE_NONPARTNER_RECEIPT	71	6.3%
COMPLETE_PARTNER_RECEIPT	39	3.5%
Receipt number 3 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	31	2.8%
Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	30	2.7%
Receipt number 5 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	27	2.4%
Receipt number 4 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	26	2.3%
Receipt number 6 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	18	1.6%
(Missing)	575	51.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
receipt	434	14.9%
bonus	434	14.9%
default	251	8.6%
number	251	8.6%
5cefdcacf3693e0b50e83a36	251	8.6%
completed	251	8.6%
point	251	8.6%
schedule	251	8.6%
all-receipts	183	6.3%
1	119	4.1%
Other values (7)	242	8.3%

Most occurring characters

Value	Count	Frequency (%)
e	3242	11.4%
	2374	8.3%
c	1872	6.6%
p	1119	3.9%
t	1119	3.9%
3	1035	3.6%
n	936	3.3%
u	936	3.3%
b	936	3.3%
o	936	3.3%
Other values (36)	13939	49.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16827	59.2%
Uppercase Letter	4824	17.0%
Decimal Number	3263	11.5%
Space Separator	2374	8.3%
Close Punctuation	251	0.9%
Open Punctuation	251	0.9%
Other Punctuation	251	0.9%
Connector Punctuation	220	0.8%
Dash Punctuation	183	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	3242	19.3%
c	1872	11.1%
p	1119	6.7%
t	1119	6.7%
n	936	5.6%
u	936	5.6%
b	936	5.6%
o	936	5.6%
s	868	5.2%
l	868	5.2%
Other values (7)	3995	23.7%

Uppercase Letter

Value	Count	Frequency (%)
E	801	16.6%
T	581	12.0%
R	581	12.0%
A	544	11.3%
L	361	7.5%
P	330	6.8%
N	252	5.2%
F	251	5.2%
U	251	5.2%
D	251	5.2%
Other values (4)	621	12.9%

Decimal Number

Value	Count	Frequency (%)
3	1035	31.7%
5	529	16.2%
6	520	15.9%
0	502	15.4%
8	251	7.7%
9	251	7.7%
1	119	3.6%
2	30	0.9%
4	26	0.8%

Space Separator

Value	Count	Frequency (%)
	2374	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	251	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	251	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	251	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	220	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	183	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21651	76.1%
Common	6793	23.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	3242	15.0%
c	1872	8.6%
p	1119	5.2%
t	1119	5.2%
n	936	4.3%
u	936	4.3%
b	936	4.3%
o	936	4.3%
s	868	4.0%
l	868	4.0%
Other values (21)	8819	40.7%

Common

Value	Count	Frequency (%)
	2374	34.9%
3	1035	15.2%
5	529	7.8%
6	520	7.7%
0	502	7.4%
)	251	3.7%
8	251	3.7%
9	251	3.7%
(	251	3.7%
,	251	3.7%
Other values (5)	578	8.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28444	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	3242	11.4%
	2374	8.3%
c	1872	6.6%
p	1119	3.9%
t	1119	3.9%
3	1035	3.6%
n	936	3.3%
u	936	3.3%
b	936	3.3%
o	936	3.3%
Other values (36)	13939	49.0%

createDate
Real number (ℝ)

Distinct	1107
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6117998 × 10¹²

Minimum	1.6040891 × 10¹²
Maximum	1.6146407 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.6040891 × 10¹²
5-th percentile	1.6097889 × 10¹²
Q1	1.6106516 × 10¹²
median	1.6119407 × 10¹²
Q3	1.612704 × 10¹²
95-th percentile	1.6144754 × 10¹²
Maximum	1.6146407 × 10¹²
Range	1.0551576 × 10¹⁰
Interquartile range (IQR)	2.05243 × 10⁹

Descriptive statistics

Standard deviation	1.484091 × 10⁹
Coefficient of variation (CV)	0.00092076632
Kurtosis	2.4018826
Mean	1.6117998 × 10¹²
Median Absolute Deviation (MAD)	9.3145338 × 10⁸
Skewness	-0.47574632
Sum	1.803604 × 10¹⁵
Variance	2.202526 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.609687531 × 10¹²	3	0.3%
1.610144383 × 10¹²	3	0.3%
1.609687534 × 10¹²	3	0.3%
1.609879107 × 10¹²	2	0.2%
1.610390945 × 10¹²	2	0.2%
1.609945606 × 10¹²	2	0.2%
1.60994556 × 10¹²	2	0.2%
1.611957559 × 10¹²	2	0.2%
1.612972619 × 10¹²	2	0.2%
1.612733265 × 10¹²	1	0.1%
Other values (1097)	1097	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.604089079 × 10¹²	1	0.1%
1.604089081 × 10¹²	1	0.1%
1.604607818 × 10¹²	1	0.1%
1.604693303 × 10¹²	1	0.1%
1.604900211 × 10¹²	1	0.1%
1.604900217 × 10¹²	1	0.1%
1.605483857 × 10¹²	1	0.1%
1.605556824 × 10¹²	1	0.1%
1.609607165 × 10¹²	1	0.1%
1.609687446 × 10¹²	1	0.1%

Value	Count	Frequency (%)
1.614640655 × 10¹²	1	0.1%
1.614634348 × 10¹²	1	0.1%
1.614633447 × 10¹²	1	0.1%
1.614626853 × 10¹²	1	0.1%
1.61462295 × 10¹²	1	0.1%
1.614620855 × 10¹²	1	0.1%
1.614613362 × 10¹²	1	0.1%
1.614607658 × 10¹²	1	0.1%
1.614607054 × 10¹²	1	0.1%
1.614604048 × 10¹²	1	0.1%

dateScanned
Real number (ℝ)

Distinct	1107
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6117998 × 10¹²

Minimum	1.6040891 × 10¹²
Maximum	1.6146407 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.6040891 × 10¹²
5-th percentile	1.6097889 × 10¹²
Q1	1.6106516 × 10¹²
median	1.6119407 × 10¹²
Q3	1.612704 × 10¹²
95-th percentile	1.6144754 × 10¹²
Maximum	1.6146407 × 10¹²
Range	1.0551576 × 10¹⁰
Interquartile range (IQR)	2.05243 × 10⁹

Descriptive statistics

Standard deviation	1.484091 × 10⁹
Coefficient of variation (CV)	0.00092076632
Kurtosis	2.4018826
Mean	1.6117998 × 10¹²
Median Absolute Deviation (MAD)	9.3145338 × 10⁸
Skewness	-0.47574632
Sum	1.803604 × 10¹⁵
Variance	2.202526 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.609687531 × 10¹²	3	0.3%
1.610144383 × 10¹²	3	0.3%
1.609687534 × 10¹²	3	0.3%
1.609879107 × 10¹²	2	0.2%
1.610390945 × 10¹²	2	0.2%
1.609945606 × 10¹²	2	0.2%
1.60994556 × 10¹²	2	0.2%
1.611957559 × 10¹²	2	0.2%
1.612972619 × 10¹²	2	0.2%
1.612733265 × 10¹²	1	0.1%
Other values (1097)	1097	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.604089079 × 10¹²	1	0.1%
1.604089081 × 10¹²	1	0.1%
1.604607818 × 10¹²	1	0.1%
1.604693303 × 10¹²	1	0.1%
1.604900211 × 10¹²	1	0.1%
1.604900217 × 10¹²	1	0.1%
1.605483857 × 10¹²	1	0.1%
1.605556824 × 10¹²	1	0.1%
1.609607165 × 10¹²	1	0.1%
1.609687446 × 10¹²	1	0.1%

Value	Count	Frequency (%)
1.614640655 × 10¹²	1	0.1%
1.614634348 × 10¹²	1	0.1%
1.614633447 × 10¹²	1	0.1%
1.614626853 × 10¹²	1	0.1%
1.61462295 × 10¹²	1	0.1%
1.614620855 × 10¹²	1	0.1%
1.614613362 × 10¹²	1	0.1%
1.614607658 × 10¹²	1	0.1%
1.614607054 × 10¹²	1	0.1%
1.614604048 × 10¹²	1	0.1%

finishedDate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	553
Distinct (%)	97.4%
Missing	551
Missing (%)	49.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.6110582 × 10¹²

Minimum	1.6096874 × 10¹²
Maximum	1.614379 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.6096874 × 10¹²
5-th percentile	1.6097881 × 10¹²
Q1	1.610141 × 10¹²
median	1.6110908 × 10¹²
Q3	1.6117693 × 10¹²
95-th percentile	1.6125454 × 10¹²
Maximum	1.614379 × 10¹²
Range	4.691535 × 10⁹
Interquartile range (IQR)	1.628371 × 10⁹

Descriptive statistics

Standard deviation	9.5346414 × 10⁸
Coefficient of variation (CV)	0.00059182476
Kurtosis	-0.79232439
Mean	1.6110582 × 10¹²
Median Absolute Deviation (MAD)	7.605265 × 10⁸
Skewness	0.3062952
Sum	9.1508106 × 10¹⁴
Variance	9.0909386 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.609687534 × 10¹²	3	0.3%
1.609687531 × 10¹²	2	0.2%
1.609687532 × 10¹²	2	0.2%
1.611641366 × 10¹²	2	0.2%
1.609788557 × 10¹²	2	0.2%
1.609788876 × 10¹²	2	0.2%
1.611173216 × 10¹²	2	0.2%
1.61038737 × 10¹²	2	0.2%
1.611172426 × 10¹²	2	0.2%
1.610144383 × 10¹²	2	0.2%
Other values (543)	547	48.9%
(Missing)	551	49.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.60968745 × 10¹²	1	0.1%
1.609687461 × 10¹²	1	0.1%
1.609687475 × 10¹²	1	0.1%
1.609687483 × 10¹²	1	0.1%
1.609687493 × 10¹²	1	0.1%
1.609687499 × 10¹²	1	0.1%
1.609687502 × 10¹²	2	0.2%
1.609687509 × 10¹²	1	0.1%
1.609687511 × 10¹²	1	0.1%
1.609687512 × 10¹²	1	0.1%

Value	Count	Frequency (%)
1.614378985 × 10¹²	1	0.1%
1.61313912 × 10¹²	1	0.1%
1.613139118 × 10¹²	1	0.1%
1.613139071 × 10¹²	1	0.1%
1.613139065 × 10¹²	1	0.1%
1.613060278 × 10¹²	1	0.1%
1.613060276 × 10¹²	1	0.1%
1.613060271 × 10¹²	1	0.1%
1.613052084 × 10¹²	1	0.1%
1.613052054 × 10¹²	1	0.1%

modifyDate
Real number (ℝ)

Distinct	1104
Distinct (%)	98.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6118469 × 10¹²

Minimum	1.6096874 × 10¹²
Maximum	1.6146407 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.6096874 × 10¹²
5-th percentile	1.6097897 × 10¹²
Q1	1.6106599 × 10¹²
median	1.6119407 × 10¹²
Q3	1.612704 × 10¹²
95-th percentile	1.6144754 × 10¹²
Maximum	1.6146407 × 10¹²
Range	4.9532048 × 10⁹
Interquartile range (IQR)	2.0440682 × 10⁹

Descriptive statistics

Standard deviation	1.3615765 × 10⁹
Coefficient of variation (CV)	0.00084473068
Kurtosis	-0.6315802
Mean	1.6118469 × 10¹²
Median Absolute Deviation (MAD)	9.128301 × 10⁸
Skewness	0.27102152
Sum	1.8036566 × 10¹⁵
Variance	1.8538906 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.609687536 × 10¹²	3	0.3%
1.610144388 × 10¹²	2	0.2%
1.609855952 × 10¹²	2	0.2%
1.61038737 × 10¹²	2	0.2%
1.61039095 × 10¹²	2	0.2%
1.611641366 × 10¹²	2	0.2%
1.612225697 × 10¹²	2	0.2%
1.612225704 × 10¹²	2	0.2%
1.612225662 × 10¹²	2	0.2%
1.609788876 × 10¹²	2	0.2%
Other values (1094)	1098	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.60968745 × 10¹²	1	0.1%
1.609687461 × 10¹²	1	0.1%
1.609687475 × 10¹²	1	0.1%
1.609687477 × 10¹²	1	0.1%
1.609687478 × 10¹²	1	0.1%
1.609687488 × 10¹²	1	0.1%
1.609687493 × 10¹²	1	0.1%
1.609687494 × 10¹²	1	0.1%
1.609687499 × 10¹²	1	0.1%
1.609687502 × 10¹²	2	0.2%

Value	Count	Frequency (%)
1.614640655 × 10¹²	1	0.1%
1.614634349 × 10¹²	1	0.1%
1.614633448 × 10¹²	1	0.1%
1.614626854 × 10¹²	1	0.1%
1.614622951 × 10¹²	1	0.1%
1.614620855 × 10¹²	1	0.1%
1.614613362 × 10¹²	1	0.1%
1.614607658 × 10¹²	1	0.1%
1.614607054 × 10¹²	1	0.1%
1.614604049 × 10¹²	1	0.1%

pointsAwardedDate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	523
Distinct (%)	97.4%
Missing	582
Missing (%)	52.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6109486 × 10¹²

Minimum	1.6040891 × 10¹²
Maximum	1.614379 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.6040891 × 10¹²
5-th percentile	1.6096875 × 10¹²
Q1	1.6100433 × 10¹²
median	1.6110896 × 10¹²
Q3	1.6117099 × 10¹²
95-th percentile	1.6124746 × 10¹²
Maximum	1.614379 × 10¹²
Range	1.0289905 × 10¹⁰
Interquartile range (IQR)	1.666597 × 10⁹

Descriptive statistics

Standard deviation	1.0567179 × 10⁹
Coefficient of variation (CV)	0.00065596004
Kurtosis	6.4349848
Mean	1.6109486 × 10¹²
Median Absolute Deviation (MAD)	7.61714 × 10⁸
Skewness	-1.0478511
Sum	8.6507938 × 10¹⁴
Variance	1.1166527 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.609687534 × 10¹²	3	0.3%
1.609687531 × 10¹²	2	0.2%
1.610144383 × 10¹²	2	0.2%
1.609788557 × 10¹²	2	0.2%
1.609879104 × 10¹²	2	0.2%
1.610557181 × 10¹²	2	0.2%
1.609788876 × 10¹²	2	0.2%
1.611173216 × 10¹²	2	0.2%
1.611172426 × 10¹²	2	0.2%
1.609687532 × 10¹²	2	0.2%
Other values (513)	516	46.1%
(Missing)	582	52.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.60408908 × 10¹²	1	0.1%
1.604900212 × 10¹²	1	0.1%
1.605483857 × 10¹²	1	0.1%
1.605556824 × 10¹²	1	0.1%
1.60968745 × 10¹²	1	0.1%
1.609687459 × 10¹²	1	0.1%
1.609687461 × 10¹²	1	0.1%
1.609687475 × 10¹²	1	0.1%
1.609687476 × 10¹²	1	0.1%
1.609687483 × 10¹²	1	0.1%

Value	Count	Frequency (%)
1.614378985 × 10¹²	1	0.1%
1.61313912 × 10¹²	1	0.1%
1.613139117 × 10¹²	1	0.1%
1.613139071 × 10¹²	1	0.1%
1.613139065 × 10¹²	1	0.1%
1.613060278 × 10¹²	1	0.1%
1.613060276 × 10¹²	1	0.1%
1.613060266 × 10¹²	1	0.1%
1.613052084 × 10¹²	1	0.1%
1.613052054 × 10¹²	1	0.1%

pointsEarned
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	119
Distinct (%)	19.5%
Missing	510
Missing (%)	45.6%
Infinite	0
Infinite (%)	0.0%
Mean	585.96289

Minimum	0
Maximum	10199.8
Zeros	4
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	5
median	150
Q3	750
95-th percentile	2035.3
Maximum	10199.8
Range	10199.8
Interquartile range (IQR)	745

Descriptive statistics

Standard deviation	1357.1669
Coefficient of variation (CV)	2.3161312
Kurtosis	25.00351
Mean	585.96289
Median Absolute Deviation (MAD)	145
Skewness	4.7279179
Sum	356851.4
Variance	1841902.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	161	14.4%
25	63	5.6%
750	49	4.4%
250	37	3.3%
50	27	2.4%
840	21	1.9%
100	18	1.6%
500	17	1.5%
300	16	1.4%
150	15	1.3%
Other values (109)	185	16.5%
(Missing)	510	45.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	0.4%
5	161	14.4%
25	63	5.6%
35	7	0.6%
50	27	2.4%
50.6	5	0.4%
50.9	1	0.1%
55	6	0.5%
91.2	2	0.2%
94.6	1	0.1%

Value	Count	Frequency (%)
10199.8	1	0.1%
9850	1	0.1%
9449.8	1	0.1%
9200	1	0.1%
8950	1	0.1%
8850	1	0.1%
8700	3	0.3%
7137.2	1	0.1%
6257.3	1	0.1%
5850	2	0.2%

purchaseDate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	358
Distinct (%)	53.4%
Missing	448
Missing (%)	40.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6085477 × 10¹²

Minimum	1.5093216 × 10¹²
Maximum	1.615225 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	1.5093216 × 10¹²
5-th percentile	1.5976224 × 10¹²
Q1	1.6098048 × 10¹²
median	1.6105511 × 10¹²
Q3	1.6116236 × 10¹²
95-th percentile	1.6124832 × 10¹²
Maximum	1.615225 × 10¹²
Range	1.0590343 × 10¹¹
Interquartile range (IQR)	1.818778 × 10⁹

Descriptive statistics

Standard deviation	1.230755 × 10¹⁰
Coefficient of variation (CV)	0.007651343
Kurtosis	55.265028
Mean	1.6085477 × 10¹²
Median Absolute Deviation (MAD)	8.48982 × 10⁸
Skewness	-7.2846834
Sum	1.0793355 × 10¹⁵
Variance	1.514758 × 10²⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.5976224 × 10¹²	40	3.6%
1.6124832 × 10¹²	28	2.5%
1.611792 × 10¹²	24	2.1%
1.6104096 × 10¹²	23	2.1%
1.6111008 × 10¹²	18	1.6%
1.6103232 × 10¹²	14	1.3%
1.6118784 × 10¹²	13	1.2%
1.6112736 × 10¹²	11	1.0%
1.6111872 × 10¹²	11	1.0%
1.6105824 × 10¹²	11	1.0%
Other values (348)	478	42.7%
(Missing)	448	40.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.5093216 × 10¹²	9	0.8%
1.5464736 × 10¹²	1	0.1%
1.5976224 × 10¹²	40	3.6%
1.5999552 × 10¹²	1	0.1%
1.604002679 × 10¹²	1	0.1%
1.604002681 × 10¹²	1	0.1%
1.604521418 × 10¹²	1	0.1%
1.604606903 × 10¹²	1	0.1%
1.604813811 × 10¹²	1	0.1%
1.604813817 × 10¹²	1	0.1%

Value	Count	Frequency (%)
1.615225033 × 10¹²	1	0.1%
1.614616873 × 10¹²	1	0.1%
1.614538558 × 10¹²	1	0.1%
1.6141248 × 10¹²	1	0.1%
1.61385007 × 10¹²	1	0.1%
1.613345597 × 10¹²	1	0.1%
1.613235569 × 10¹²	1	0.1%
1.613235566 × 10¹²	1	0.1%
1.613088 × 10¹²	2	0.2%
1.613075216 × 10¹²	1	0.1%

purchasedItemCount
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	50
Distinct (%)	7.9%
Missing	484
Missing (%)	43.3%
Infinite	0
Infinite (%)	0.0%
Mean	14.75748

Minimum	0
Maximum	689
Zeros	15
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	88.1
Maximum	689
Range	689
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	61.13424
Coefficient of variation (CV)	4.1425934
Kurtosis	62.320237
Mean	14.75748
Median Absolute Deviation (MAD)	1
Skewness	7.170786
Sum	9371
Variance	3737.3954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	245	21.9%
2	113	10.1%
5	90	8.0%
4	67	6.0%
3	23	2.1%
0	15	1.3%
10	12	1.1%
9	10	0.9%
6	7	0.6%
11	5	0.4%
Other values (40)	48	4.3%
(Missing)	484	43.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15	1.3%
1	245	21.9%
2	113	10.1%
3	23	2.1%
4	67	6.0%
5	90	8.0%
6	7	0.6%
7	3	0.3%
8	2	0.2%
9	10	0.9%

Value	Count	Frequency (%)
689	1	0.1%
670	1	0.1%
599	1	0.1%
348	1	0.1%
341	1	0.1%
335	1	0.1%
309	1	0.1%
303	1	0.1%
240	1	0.1%
229	1	0.1%

rewardsReceiptItemList
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	440
Missing (%)	39.3%
Memory size	8.9 KiB

rewardsReceiptStatus
Categorical

Distinct	5
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

FINISHED	518
SUBMITTED	434
REJECTED	71
PENDING	50
FLAGGED	46

Length

Max length	9
Median length	8
Mean length	8.3020554
Min length	7

Characters and Unicode

Total characters	9290
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FINISHED
2nd row	FINISHED
3rd row	REJECTED
4th row	FINISHED
5th row	FINISHED

Common Values

Value	Count	Frequency (%)
FINISHED	518	46.3%
SUBMITTED	434	38.8%
REJECTED	71	6.3%
PENDING	50	4.5%
FLAGGED	46	4.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
finished	518	46.3%
submitted	434	38.8%
rejected	71	6.3%
pending	50	4.5%
flagged	46	4.1%

Most occurring characters

Value	Count	Frequency (%)
I	1520	16.4%
E	1261	13.6%
D	1119	12.0%
S	952	10.2%
T	939	10.1%
N	618	6.7%
F	564	6.1%
H	518	5.6%
M	434	4.7%
B	434	4.7%
Other values (8)	931	10.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9290	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	1520	16.4%
E	1261	13.6%
D	1119	12.0%
S	952	10.2%
T	939	10.1%
N	618	6.7%
F	564	6.1%
H	518	5.6%
M	434	4.7%
B	434	4.7%
Other values (8)	931	10.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9290	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	1520	16.4%
E	1261	13.6%
D	1119	12.0%
S	952	10.2%
T	939	10.1%
N	618	6.7%
F	564	6.1%
H	518	5.6%
M	434	4.7%
B	434	4.7%
Other values (8)	931	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9290	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	1520	16.4%
E	1261	13.6%
D	1119	12.0%
S	952	10.2%
T	939	10.1%
N	618	6.7%
F	564	6.1%
H	518	5.6%
M	434	4.7%
B	434	4.7%
Other values (8)	931	10.0%

totalSpent
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	94
Distinct (%)	13.7%
Missing	435
Missing (%)	38.9%
Infinite	0
Infinite (%)	0.0%
Mean	77.796857

Minimum	0
Maximum	4721.95
Zeros	15
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	8.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	18.2
Q3	34.96
95-th percentile	290
Maximum	4721.95
Range	4721.95
Interquartile range (IQR)	33.96

Descriptive statistics

Standard deviation	347.11035
Coefficient of variation (CV)	4.4617529
Kurtosis	122.95658
Mean	77.796857
Median Absolute Deviation (MAD)	16.76
Skewness	10.203611
Sum	53213.05
Variance	120485.59
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	172	15.4%
10	54	4.8%
28.57	50	4.5%
34.96	44	3.9%
49.95	43	3.8%
25	28	2.5%
84	22	2.0%
4.66	15	1.3%
0	15	1.3%
9.99	14	1.3%
Other values (84)	227	20.3%
(Missing)	435	38.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15	1.3%
0.16	1	0.1%
0.99	7	0.6%
1	172	15.4%
2	4	0.4%
2.23	7	0.6%
2.29	1	0.1%
2.99	1	0.1%
3	9	0.8%
3.09	5	0.4%

Value	Count	Frequency (%)
4721.95	1	0.1%
4566.17	1	0.1%
4368.8	1	0.1%
2084.82	1	0.1%
1198.68	1	0.1%
1183.1	1	0.1%
1177.84	1	0.1%
1107.82	1	0.1%
1083.24	1	0.1%
1043.18	1	0.1%

userId
Categorical

Distinct	258
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

5fc961c3b8cfca11a077dd33	436
59c124bae4b0299e55b0f330	58
54943462e4b07e684157a532	50
5fa41775898c7a11a6bcef3e	21
5ff5d15aeb7c7d12096d91a2	20
Other values (253)	534

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	26856
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	167 ?
Unique (%)	14.9%

Sample

1st row	5ff1e1eacfcf6c399c274ae6
2nd row	5ff1e194b6a9d73a3a9f1052
3rd row	5ff1e1f1cfcf6c399c274b0b
4th row	5ff1e1eacfcf6c399c274ae6
5th row	5ff1e194b6a9d73a3a9f1052

Common Values

Value	Count	Frequency (%)
5fc961c3b8cfca11a077dd33	436	39.0%
59c124bae4b0299e55b0f330	58	5.2%
54943462e4b07e684157a532	50	4.5%
5fa41775898c7a11a6bcef3e	21	1.9%
5ff5d15aeb7c7d12096d91a2	20	1.8%
600fb1ac73c60b12049027bb	16	1.4%
5ff1e194b6a9d73a3a9f1052	14	1.3%
5ff47392c3d63511e2a47881	10	0.9%
600987d77d983a11f63cfa92	10	0.9%
5a43c08fe4b014fd6b6a0612	9	0.8%
Other values (248)	475	42.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
5fc961c3b8cfca11a077dd33	436	39.0%
59c124bae4b0299e55b0f330	58	5.2%
54943462e4b07e684157a532	50	4.5%
5fa41775898c7a11a6bcef3e	21	1.9%
5ff5d15aeb7c7d12096d91a2	20	1.8%
600fb1ac73c60b12049027bb	16	1.4%
5ff1e194b6a9d73a3a9f1052	14	1.3%
5ff47392c3d63511e2a47881	10	0.9%
600987d77d983a11f63cfa92	10	0.9%
5a43c08fe4b014fd6b6a0612	9	0.8%
Other values (248)	475	42.4%

Most occurring characters

Value	Count	Frequency (%)
1	2923	10.9%
c	2547	9.5%
3	2412	9.0%
f	1957	7.3%
0	1795	6.7%
a	1695	6.3%
7	1674	6.2%
5	1596	5.9%
d	1532	5.7%
b	1523	5.7%
Other values (6)	7202	26.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16734	62.3%
Lowercase Letter	10122	37.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2923	17.5%
3	2412	14.4%
0	1795	10.7%
7	1674	10.0%
5	1596	9.5%
6	1491	8.9%
9	1450	8.7%
8	1264	7.6%
4	1181	7.1%
2	948	5.7%

Lowercase Letter

Value	Count	Frequency (%)
c	2547	25.2%
f	1957	19.3%
a	1695	16.7%
d	1532	15.1%
b	1523	15.0%
e	868	8.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	16734	62.3%
Latin	10122	37.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2923	17.5%
3	2412	14.4%
0	1795	10.7%
7	1674	10.0%
5	1596	9.5%
6	1491	8.9%
9	1450	8.7%
8	1264	7.6%
4	1181	7.1%
2	948	5.7%

Latin

Value	Count	Frequency (%)
c	2547	25.2%
f	1957	19.3%
a	1695	16.7%
d	1532	15.1%
b	1523	15.0%
e	868	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2923	10.9%
c	2547	9.5%
3	2412	9.0%
f	1957	7.3%
0	1795	6.7%
a	1695	6.3%
7	1674	6.2%
5	1596	5.9%
d	1532	5.7%
b	1523	5.7%
Other values (6)	7202	26.8%

Auto

Heatmap
Table

	bonusPointsEarned	createDate	dateScanned	finishedDate	modifyDate	pointsAwardedDate	pointsEarned	purchaseDate	purchasedItemCount	totalSpent	bonusPointsEarnedReason	rewardsReceiptStatus
bonusPointsEarned	1.000	-0.107	-0.107	-0.031	-0.086	-0.066	0.193	0.012	0.243	0.120	0.996	0.182
createDate	-0.107	1.000	1.000	0.993	0.993	0.991	-0.134	0.551	-0.013	0.195	0.305	0.397
dateScanned	-0.107	1.000	1.000	0.993	0.993	0.991	-0.134	0.551	-0.013	0.195	0.305	0.397
finishedDate	-0.031	0.993	0.993	1.000	1.000	1.000	0.037	0.920	0.042	0.131	0.081	0.747
modifyDate	-0.086	0.993	0.993	1.000	1.000	0.974	-0.114	0.529	0.019	0.182	0.281	0.431
pointsAwardedDate	-0.066	0.991	0.991	1.000	0.974	1.000	0.003	0.915	0.012	0.127	0.055	0.701
pointsEarned	0.193	-0.134	-0.134	0.037	-0.114	0.003	1.000	0.134	0.067	-0.028	0.851	0.560
purchaseDate	0.012	0.551	0.551	0.920	0.529	0.915	0.134	1.000	-0.009	-0.006	0.668	0.475
purchasedItemCount	0.243	-0.013	-0.013	0.042	0.019	0.012	0.067	-0.009	1.000	0.644	0.119	0.077
totalSpent	0.120	0.195	0.195	0.131	0.182	0.127	-0.028	-0.006	0.644	1.000	0.306	0.772
bonusPointsEarnedReason	0.996	0.305	0.305	0.081	0.281	0.055	0.851	0.668	0.119	0.306	1.000	0.433
rewardsReceiptStatus	0.182	0.397	0.397	0.747	0.431	0.701	0.560	0.475	0.077	0.772	0.433	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	_id	bonusPointsEarned	bonusPointsEarnedReason	createDate	dateScanned	finishedDate	modifyDate	pointsAwardedDate	pointsEarned	purchaseDate	purchasedItemCount	rewardsReceiptItemList	rewardsReceiptStatus	totalSpent	userId
0	5ff1e1eb0a720f0523000575	500.0	Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	1609687531000	1609687531000	1.609688e+12	1609687536000	1.609688e+12	500.0	1.609632e+12	5.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '26.00', 'itemPrice': '26.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 5, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '26.00', 'userFlaggedQuantity': 5, '_id': '5ff1e1eb0a720f0523000575'}]	FINISHED	26.00	5ff1e1eacfcf6c399c274ae6
1	5ff1e1bb0a720f052300056b	150.0	Receipt number 5 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	1609687483000	1609687483000	1.609687e+12	1609687488000	1.609687e+12	150.0	1.609601e+12	2.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '1', 'itemPrice': '1', 'partnerItemId': '1', 'quantityPurchased': 1, '_id': '5ff1e1bb0a720f052300056b'}, {'barcode': '028400642255', 'description': 'DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ', 'finalPrice': '10.00', 'itemPrice': '10.00', 'needsFetchReview': True, 'needsFetchReviewReason': 'USER_FLAGGED', 'partnerItemId': '2', 'pointsNotAwardedReason': 'Action not allowed for user and CPG', 'pointsPayerId': '5332f5fbe4b03c9a25efd0ba', 'preventTargetGapPoints': True, 'quantityPurchased': 1, 'rewardsGroup': 'DORITOS SPICY SWEET CHILI SINGLE SERVE', 'rewardsProductPartnerId': '5332f5fbe4b03c9a25efd0ba', 'userFlaggedBarcode': '028400642255', 'userFlaggedDescription': 'DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ', 'userFlaggedNewItem': True, 'userFlaggedPrice': '10.00', 'userFlaggedQuantity': 1, '_id': '5ff1e1bb0a720f052300056b'}]	FINISHED	11.00	5ff1e194b6a9d73a3a9f1052
2	5ff1e1f10a720f052300057a	5.0	All-receipts receipt bonus	1609687537000	1609687537000	NaN	1609687542000	NaN	5	1.609632e+12	1.0	[{'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '26.00', 'userFlaggedQuantity': 3, '_id': '5ff1e1f10a720f052300057a'}]	REJECTED	10.00	5ff1e1f1cfcf6c399c274b0b
3	5ff1e1ee0a7214ada100056f	5.0	All-receipts receipt bonus	1609687534000	1609687534000	1.609688e+12	1609687539000	1.609688e+12	5.0	1.609632e+12	4.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '28.00', 'itemPrice': '28.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 4, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '28.00', 'userFlaggedQuantity': 4, '_id': '5ff1e1ee0a7214ada100056f'}]	FINISHED	28.00	5ff1e1eacfcf6c399c274ae6
4	5ff1e1d20a7214ada1000561	5.0	All-receipts receipt bonus	1609687506000	1609687506000	1.609688e+12	1609687511000	1.609688e+12	5.0	1.609601e+12	2.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '1', 'itemPrice': '1', 'partnerItemId': '1', 'quantityPurchased': 1, '_id': '5ff1e1d20a7214ada1000561'}, {'barcode': '1234', 'finalPrice': '2.56', 'itemPrice': '2.56', 'needsFetchReview': True, 'needsFetchReviewReason': 'USER_FLAGGED', 'partnerItemId': '2', 'preventTargetGapPoints': True, 'quantityPurchased': 3, 'userFlaggedBarcode': '1234', 'userFlaggedDescription': '', 'userFlaggedNewItem': True, 'userFlaggedPrice': '2.56', 'userFlaggedQuantity': 3, '_id': '5ff1e1d20a7214ada1000561'}]	FINISHED	1.00	5ff1e194b6a9d73a3a9f1052
5	5ff1e1e40a7214ada1000566	750.0	Receipt number 1 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	1609687524000	1609687524000	1.609688e+12	1609687530000	1.609688e+12	750.0	1.609601e+12	1.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '3.25', 'itemPrice': '3.25', 'needsFetchReview': False, 'originalMetaBriteBarcode': '028400642255', 'originalMetaBriteDescription': 'DORITOS TORTILLA CHIP SPICY SWEET CHILI REDUCED FAT BAG 1 OZ', 'partnerItemId': '1', 'pointsNotAwardedReason': 'Action not allowed for user and CPG', 'pointsPayerId': '5332f5fbe4b03c9a25efd0ba', 'preventTargetGapPoints': True, 'quantityPurchased': 1, 'rewardsGroup': 'DORITOS SPICY SWEET CHILI SINGLE SERVE', 'rewardsProductPartnerId': '5332f5fbe4b03c9a25efd0ba', 'userFlaggedBarcode': '4011', '_id': '5ff1e1e40a7214ada1000566'}]	FINISHED	3.25	5ff1e1e4cfcf6c399c274ac3
6	5ff1e1cd0a720f052300056f	5.0	All-receipts receipt bonus	1609687501000	1609687501000	1.609688e+12	1609687502000	1.609688e+12	5.0	1.609688e+12	1.0	[{'brandCode': 'MISSION', 'competitorRewardsGroup': 'TACO BELL TACO SHELLS', 'description': 'MSSN TORTLLA', 'discountedItemPrice': '2.23', 'finalPrice': '2.23', 'itemPrice': '2.23', 'originalReceiptItemText': 'MSSN TORTLLA', 'partnerItemId': '1009', 'quantityPurchased': 1, '_id': '5ff1e1cd0a720f052300056f'}]	FINISHED	2.23	5ff1e194b6a9d73a3a9f1052
7	5ff1e1a40a720f0523000569	500.0	Receipt number 2 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	1609687460000	1609687460000	1.609687e+12	1609687461000	1.609687e+12	500.0	1.609027e+12	1.0	[{'barcode': '046000832517', 'brandCode': 'BRAND', 'description': 'Old El Paso Mild Chopped Green Chiles, 4.5 Oz', 'finalPrice': '10.00', 'itemPrice': '10.00', 'partnerItemId': '0', 'pointsNotAwardedReason': 'Action not allowed for user and CPG', 'pointsPayerId': '5332f5f3e4b03c9a25efd0ae', 'quantityPurchased': 1, 'rewardsGroup': 'OLD EL PASO BEANS & PEPPERS', 'rewardsProductPartnerId': '5332f5f3e4b03c9a25efd0ae', '_id': '5ff1e1a40a720f0523000569'}]	FINISHED	10.00	5ff1e194b6a9d73a3a9f1052
8	5ff1e1ed0a7214ada100056e	5.0	All-receipts receipt bonus	1609687533000	1609687533000	1.609688e+12	1609687538000	1.609688e+12	5.0	1.609632e+12	5.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '20.00', 'itemPrice': '20.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 5, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '20.00', 'userFlaggedQuantity': 5, '_id': '5ff1e1ed0a7214ada100056e'}]	FINISHED	20.00	5ff1e1eacfcf6c399c274ae6
9	5ff1e1eb0a7214ada100056b	250.0	Receipt number 3 completed, bonus point schedule DEFAULT (5cefdcacf3693e0b50e83a36)	1609687531000	1609687531000	1.609688e+12	1609687536000	1.609688e+12	250.0	1.609632e+12	3.0	[{'barcode': '4011', 'description': 'ITEM NOT FOUND', 'finalPrice': '20.00', 'itemPrice': '20.00', 'needsFetchReview': False, 'partnerItemId': '1', 'preventTargetGapPoints': True, 'quantityPurchased': 3, 'userFlaggedBarcode': '4011', 'userFlaggedNewItem': True, 'userFlaggedPrice': '20.00', 'userFlaggedQuantity': 3, '_id': '5ff1e1eb0a7214ada100056b'}]	FINISHED	20.00	5ff1e1eacfcf6c399c274ae6

	_id	bonusPointsEarned	bonusPointsEarnedReason	createDate	dateScanned	finishedDate	modifyDate	pointsAwardedDate	pointsEarned	purchaseDate	purchasedItemCount	rewardsReceiptItemList	rewardsReceiptStatus	totalSpent	userId
1109	603c4a0e0a720fde10000380	NaN	NaN	1614563854494	1614563854494	NaN	1614563854494	NaN	NaN	NaN	NaN	NaN	SUBMITTED	NaN	5fc961c3b8cfca11a077dd33
1110	603c6adf0a720fde1000039a	NaN	NaN	1614572255736	1614572255736	NaN	1614572255736	NaN	NaN	NaN	NaN	NaN	SUBMITTED	NaN	5fc961c3b8cfca11a077dd33
1111	603c9e6e0a720fde100003c7	NaN	NaN	1614585454307	1614585454307	NaN	1614585454307	NaN	NaN	NaN	NaN	NaN	SUBMITTED	NaN	5fc961c3b8cfca11a077dd33
1112	603c3d240a720fde10000373	25.0	COMPLETE_NONPARTNER_RECEIPT	1614560548000	1614560548000	NaN	1614560549000	NaN	25.0	1.597622e+12	2.0	[{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603c3d240a720fde10000373'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603c3d240a720fde10000373'}]	REJECTED	34.96	5fc961c3b8cfca11a077dd33
1113	603cc2bc0a720fde100003e9	25.0	COMPLETE_NONPARTNER_RECEIPT	1614594748000	1614594748000	NaN	1614594749000	NaN	25.0	1.597622e+12	2.0	[{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603cc2bc0a720fde100003e9'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603cc2bc0a720fde100003e9'}]	REJECTED	34.96	5fc961c3b8cfca11a077dd33
1114	603cc0630a720fde100003e6	25.0	COMPLETE_NONPARTNER_RECEIPT	1614594147000	1614594147000	NaN	1614594148000	NaN	25.0	1.597622e+12	2.0	[{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603cc0630a720fde100003e6'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603cc0630a720fde100003e6'}]	REJECTED	34.96	5fc961c3b8cfca11a077dd33
1115	603d0b710a720fde1000042a	NaN	NaN	1614613361873	1614613361873	NaN	1614613361873	NaN	NaN	NaN	NaN	NaN	SUBMITTED	NaN	5fc961c3b8cfca11a077dd33
1116	603cf5290a720fde10000413	NaN	NaN	1614607657664	1614607657664	NaN	1614607657664	NaN	NaN	NaN	NaN	NaN	SUBMITTED	NaN	5fc961c3b8cfca11a077dd33
1117	603ce7100a7217c72c000405	25.0	COMPLETE_NONPARTNER_RECEIPT	1614604048000	1614604048000	NaN	1614604049000	NaN	25.0	1.597622e+12	2.0	[{'barcode': 'B076FJ92M4', 'description': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'discountedItemPrice': '22.97', 'finalPrice': '22.97', 'itemPrice': '22.97', 'originalReceiptItemText': 'mueller austria hypergrind precision electric spice/coffee grinder millwith large grinding capacity and hd motor also for spices, herbs, nuts,grains, white', 'partnerItemId': '0', 'priceAfterCoupon': '22.97', 'quantityPurchased': 1, '_id': '603ce7100a7217c72c000405'}, {'barcode': 'B07BRRLSVC', 'description': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'discountedItemPrice': '11.99', 'finalPrice': '11.99', 'itemPrice': '11.99', 'originalReceiptItemText': 'thindust summer face mask - sun protection neck gaiter for outdooractivities', 'partnerItemId': '1', 'priceAfterCoupon': '11.99', 'quantityPurchased': 1, '_id': '603ce7100a7217c72c000405'}]	REJECTED	34.96	5fc961c3b8cfca11a077dd33
1118	603c4fea0a7217c72c000389	NaN	NaN	1614565354962	1614565354962	NaN	1614565354962	NaN	NaN	NaN	NaN	NaN	SUBMITTED	NaN	5fc961c3b8cfca11a077dd33

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Close Punctuation

Open Punctuation

Other Punctuation

Connector Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample